// 添加计划事项
module.exports.sqlInserPlanItem = `
  INSERT INTO plan
  (id, content,completed)
  VALUES(?,?,?)
`

// 删除计划事项
module.exports.sqlDeletePlanItem = `
    DELETE FROM plan WHERE id=?
`
 
// 查找全部计划事项
module.exports.sqlGetPlanItemAll = `
    SELECT * FROM plan
`

// 查找指定计划事项
module.exports.sqlGetPlanItem = `
    SELECT * FROM plan where id =?
`

// 修改计划事项
module.exports.sqlUpdatePlanItem = `
    UPDATE plan
    SET content = ?,completed=?,id=?
    WHERE id = ?
`
    
// 切换计划事项完成状态
module.exports.sqlToggleCompletedStatus = `
    UPDATE plan
    SET completed=?
    WHERE id = ?
`